<?php
include "../../fun.php";
isLogin();
$db=conndb();
?>
<!DOCTYPE html>
<html>

<head>
  <meta charset="utf-8">
  <title>工程案例</title>
  <meta name="renderer" content="webkit">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <meta name="viewport"
    content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
  <link rel="stylesheet" href="../../static/layuiAdmin.std-v1.7.1/src/layuiadmin/layui/css/layui.css" media="all">
  <link rel="stylesheet" href="../../static/layuiAdmin.std-v1.7.1/src/layuiadmin/style/admin.css" media="all">
</head>

<body>

  <div class="layui-fluid">
    <div class="layui-card">
      <div class="layui-card-body"> 
        <div style="padding-bottom: 10px;">
            <button class="layui-btn layuiadmin-btn-list" data-type="batchdel">删除</button>
        </div>
        <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table>
        <!-- 显示格式化时间 -->
        <script type="text/html" id="timeTpl">
          <!-- php时间戳是秒为单位     js，java是毫秒 -->
          {{layui.util.toDateString(d.time*1000,"yyyy年MM月dd日")}}
        </script>
        <!-- 操作部分 -->
      </div>
    </div>
  </div>

  <script src="../../static/layuiAdmin.std-v1.7.1/src/layuiadmin/layui/layui.js"></script>
  <script>
    layui.config({
      base: '../../static/layuiAdmin.std-v1.7.1/src/layuiadmin/' //静态资源所在路径
    }).extend({
      index: 'lib/index' //主入口模块
    }).use(['index', 'table'], function() {
      var table = layui.table,
        form = layui.form;

      //第一个实例
      table.render({
        elem: '#LAY-app-content-list',
        // ,height: 312
        url: './list.php', //数据接口
        limit:5,
        limits:[5,10,15,20],
        page: true, //开启分页
        cols: [[ //表头
            {type:'checkbox',fixed:'left'}
            ,{field: 'id', title: 'ID', width:80, sort: true, fixed: 'left',align:'center'}
            ,{field: 'username', title: '用户名',align:'center'}
            ,{field: 'phone', title: '联系电话',align:'center'}
            ,{field: 'qq', title: 'qq',align:'center'} 
            ,{field: 'email', title: '邮箱',align:'center'}
            ,{field: 'title', title: '留言标题',align:'center'}
            ,{field: 'content', title: '留言内容',align:'center'}
            ,{field: 'time', title: '留言时间',templet: '#timeTpl',align:'center'}
        ]]
      });

      var $ = layui.$,
        active = {
          batchdel: function() {
            var checkStatus = table.checkStatus('LAY-app-content-list'),
              checkData = checkStatus.data; //得到选中的数据  数组

            if (checkData.length === 0) {
              return layer.msg('请选择数据');
            }
            var ids = [];
            checkData.forEach(el => {
              ids.push(el.id); //得到选中数据的id，放入数组ids中
            });
            layer.confirm('确定删除吗？', function(index) {

              //执行 Ajax 后重载
              $.ajax({
                url: "./del.php",
                data: {
                  id: ids.toString()
                },
                dataType: "json",
                success: function(res) {
                  if (res.code == 0) {
                    table.reload('LAY-app-content-list');
                    layer.msg('已删除');
                  }
                }
              });
            });
          }
        };

      $('.layui-btn.layuiadmin-btn-list').on('click', function() {
        var type = $(this).data('type');
        active[type] ? active[type].call(this) : '';
      });
    });
  </script>
</body>

</html>